package nc.impl.cad.templettable;

public class MigrateTempTable implements ITempTableInfo {

	public int getColumns() {
		return 8;
	}

	public String getDB2Columns() {
		return " PK_TASK VARCHAR(20),PK_COMPDEF VARCHAR(20),PK_TALLY VARCHAR(20),PK_CONTRACT VARCHAR(20),PK_DUEBILL VARCHAR(20),PK_DEGREE VARCHAR(20),DEGREENUM INTEGER,AMOUNT DECIMAL(28,8) ";

	}

	public String getDB2Indexs() {
		return " PK_TALLY ";
	}

	public String getOracleColumns() {
		return " PK_TASK VARCHAR2(20),PK_COMPDEF VARCHAR2(20),PK_TALLY VARCHAR2(20),PK_CONTRACT VARCHAR2(20),PK_DUEBILL VARCHAR2(20),PK_DEGREE VARCHAR2(20),DEGREENUM INTEGER,AMOUNT NUMBER(28,8) ";
	}

	public String getOracleIndexs() {
		return "  PK_TALLY ";
	}

	public String getTableName() {
		return "CAD_TEMP_MIGRATE";
	}
}